Dataset statistics
| Number of variables | 21 |
|---|---|
| Number of observations | 51707 |
| Missing cells | 0 |
| Missing cells (%) | 0.0% |
| Duplicate rows | 0 |
| Duplicate rows (%) | 0.0% |
| Total size in memory | 6.9 MiB |
| Average record size in memory | 140.0 B |
Variable types
| Numeric | 12 |
|---|---|
| Categorical | 5 |
| Boolean | 4 |
cleanliness_rating is highly overall correlated with guest_satisfaction_overall | High correlation |
guest_satisfaction_overall is highly overall correlated with cleanliness_rating | High correlation |
dist is highly overall correlated with rest_index_norm | High correlation |
attr_index is highly overall correlated with attr_index_norm and 2 other fields | High correlation |
attr_index_norm is highly overall correlated with attr_index and 3 other fields | High correlation |
rest_index is highly overall correlated with attr_index and 2 other fields | High correlation |
rest_index_norm is highly overall correlated with dist and 3 other fields | High correlation |
lng is highly overall correlated with city | High correlation |
lat is highly overall correlated with attr_index_norm and 1 other fields | High correlation |
room_type is highly overall correlated with room_shared and 1 other fields | High correlation |
room_shared is highly overall correlated with room_type | High correlation |
room_private is highly overall correlated with room_type and 1 other fields | High correlation |
person_capacity is highly overall correlated with room_private | High correlation |
city is highly overall correlated with lng and 1 other fields | High correlation |
room_shared is highly imbalanced (93.9%) | Imbalance |
realSum is highly skewed (γ1 = 21.41995656) | Skewed |
dist has unique values | Unique |
metro_dist has unique values | Unique |
attr_index has unique values | Unique |
rest_index has unique values | Unique |
bedrooms has 4485 (8.7%) zeros | Zeros |
Reproduction
| Analysis started | 2023-08-12 13:50:11.004005 |
|---|---|
| Analysis finished | 2023-08-12 13:50:45.285073 |
| Duration | 34.28 seconds |
| Software version | ydata-profiling vv4.5.0 |
| Download configuration | config.json |
realSum
Real number (ℝ)
SKEWED
| Distinct | 10497 |
|---|---|
| Distinct (%) | 20.3% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 279.87959 |
| Minimum | 34.779339 |
|---|---|
| Maximum | 18545.45 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 404.1 KiB |
Quantile statistics
| Minimum | 34.779339 |
|---|---|
| 5-th percentile | 96.079488 |
| Q1 | 148.75217 |
| median | 211.34309 |
| Q3 | 319.69429 |
| 95-th percentile | 661.98641 |
| Maximum | 18545.45 |
| Range | 18510.671 |
| Interquartile range (IQR) | 170.94211 |
Descriptive statistics
| Standard deviation | 327.94839 |
|---|---|
| Coefficient of variation (CV) | 1.1717481 |
| Kurtosis | 831.35586 |
| Mean | 279.87959 |
| Median Absolute Deviation (MAD) | 75.403862 |
| Skewness | 21.419957 |
| Sum | 14471734 |
| Variance | 107550.14 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 184.4621607 | 188 | 0.4% |
| 161.5505108 | 167 | 0.3% |
| 126.7154513 | 162 | 0.3% |
| 115.9984065 | 145 | 0.3% |
| 138.9637476 | 133 | 0.3% |
| 104.2813957 | 128 | 0.2% |
| 207.6076029 | 128 | 0.2% |
| 149.8608936 | 127 | 0.2% |
| 103.8038015 | 126 | 0.2% |
| 230.5192528 | 116 | 0.2% |
| Other values (10487) | 50287 |
| Value | Count | Frequency (%) |
| 34.77933919 | 1 | < 0.1% |
| 37.12929454 | 1 | < 0.1% |
| 39.00925882 | 1 | < 0.1% |
| 40.1842365 | 1 | < 0.1% |
| 42.88425937 | 5 | |
| 44.1791606 | 1 | < 0.1% |
| 45.22766152 | 8 | |
| 46.05709209 | 3 | < 0.1% |
| 46.16502238 | 2 | < 0.1% |
| 46.39936259 | 3 | < 0.1% |
| Value | Count | Frequency (%) |
| 18545.45028 | 1 | |
| 16445.61469 | 1 | |
| 15499.89416 | 1 | |
| 13664.30592 | 1 | |
| 13656.35883 | 1 | |
| 12942.99138 | 1 | |
| 12937.2751 | 1 | |
| 12929.51386 | 1 | |
| 12886.23909 | 2 | |
| 12076.95383 | 1 |
room_type
Categorical
HIGH CORRELATION
| Distinct | 3 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 404.1 KiB |
| Entire home/apt | |
|---|---|
| Private room | |
| Shared room | 366 |
Length
| Max length | 15 |
|---|---|
| Median length | 15 |
| Mean length | 13.887133 |
| Min length | 11 |
Characters and Unicode
| Total characters | 718062 |
|---|---|
| Distinct characters | 17 |
| Distinct categories | 4 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Private room |
|---|---|
| 2nd row | Private room |
| 3rd row | Private room |
| 4th row | Private room |
| 5th row | Private room |
Common Values
| Value | Count | Frequency (%) |
| Entire home/apt | 32648 | |
| Private room | 18693 | |
| Shared room | 366 | 0.7% |
Length
Histogram of lengths of the category
Common Values (Plot)
| Value | Count | Frequency (%) |
| entire | 32648 | |
| home/apt | 32648 | |
| room | 19059 | |
| private | 18693 | |
| shared | 366 | 0.4% |
Most occurring characters
| Value | Count | Frequency (%) |
| e | 84355 | |
| t | 83989 | |
| o | 70766 | |
| r | 70766 | |
| a | 51707 | 7.2% |
| 51707 | 7.2% | |
| m | 51707 | 7.2% |
| i | 51341 | 7.1% |
| h | 33014 | 4.6% |
| p | 32648 | 4.5% |
| Other values (7) | 136062 |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 582000 | |
| Space Separator | 51707 | 7.2% |
| Uppercase Letter | 51707 | 7.2% |
| Other Punctuation | 32648 | 4.5% |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| e | 84355 | |
| t | 83989 | |
| o | 70766 | |
| r | 70766 | |
| a | 51707 | |
| m | 51707 | |
| i | 51341 | |
| h | 33014 | 5.7% |
| p | 32648 | 5.6% |
| n | 32648 | 5.6% |
| Other values (2) | 19059 | 3.3% |
Uppercase Letter
| Value | Count | Frequency (%) |
| E | 32648 | |
| P | 18693 | |
| S | 366 | 0.7% |
Space Separator
| Value | Count | Frequency (%) |
| 51707 |
Other Punctuation
| Value | Count | Frequency (%) |
| / | 32648 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 633707 | |
| Common | 84355 | 11.7% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| e | 84355 | |
| t | 83989 | |
| o | 70766 | |
| r | 70766 | |
| a | 51707 | |
| m | 51707 | |
| i | 51341 | |
| h | 33014 | 5.2% |
| p | 32648 | 5.2% |
| E | 32648 | 5.2% |
| Other values (5) | 70766 |
Common
| Value | Count | Frequency (%) |
| 51707 | ||
| / | 32648 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 718062 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| e | 84355 | |
| t | 83989 | |
| o | 70766 | |
| r | 70766 | |
| a | 51707 | 7.2% |
| 51707 | 7.2% | |
| m | 51707 | 7.2% |
| i | 51341 | 7.1% |
| h | 33014 | 4.6% |
| p | 32648 | 4.5% |
| Other values (7) | 136062 |
room_shared
Boolean
HIGH CORRELATION IMBALANCE
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 50.6 KiB |
| False | |
|---|---|
| True | 366 |
| Value | Count | Frequency (%) |
| False | 51341 | |
| True | 366 | 0.7% |
room_private
Boolean
HIGH CORRELATION
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 50.6 KiB |
| False | |
|---|---|
| True |
| Value | Count | Frequency (%) |
| False | 33014 | |
| True | 18693 |
person_capacity
Categorical
HIGH CORRELATION
| Distinct | 5 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 404.1 KiB |
| 2.0 | |
|---|---|
| 4.0 | |
| 3.0 | |
| 6.0 | |
| 5.0 |
Length
| Max length | 3 |
|---|---|
| Median length | 3 |
| Mean length | 3 |
| Min length | 3 |
Characters and Unicode
| Total characters | 155121 |
|---|---|
| Distinct characters | 7 |
| Distinct categories | 2 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 2.0 |
|---|---|
| 2nd row | 4.0 |
| 3rd row | 2.0 |
| 4th row | 4.0 |
| 5th row | 2.0 |
Common Values
| Value | Count | Frequency (%) |
| 2.0 | 24333 | |
| 4.0 | 14000 | |
| 3.0 | 6165 | 11.9% |
| 6.0 | 4274 | 8.3% |
| 5.0 | 2935 | 5.7% |
Length
Histogram of lengths of the category
Common Values (Plot)
| Value | Count | Frequency (%) |
| 2.0 | 24333 | |
| 4.0 | 14000 | |
| 3.0 | 6165 | 11.9% |
| 6.0 | 4274 | 8.3% |
| 5.0 | 2935 | 5.7% |
Most occurring characters
| Value | Count | Frequency (%) |
| . | 51707 | |
| 0 | 51707 | |
| 2 | 24333 | |
| 4 | 14000 | 9.0% |
| 3 | 6165 | 4.0% |
| 6 | 4274 | 2.8% |
| 5 | 2935 | 1.9% |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 103414 | |
| Other Punctuation | 51707 |
Most frequent character per category
Decimal Number
| Value | Count | Frequency (%) |
| 0 | 51707 | |
| 2 | 24333 | |
| 4 | 14000 | 13.5% |
| 3 | 6165 | 6.0% |
| 6 | 4274 | 4.1% |
| 5 | 2935 | 2.8% |
Other Punctuation
| Value | Count | Frequency (%) |
| . | 51707 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 155121 |
Most frequent character per script
Common
| Value | Count | Frequency (%) |
| . | 51707 | |
| 0 | 51707 | |
| 2 | 24333 | |
| 4 | 14000 | 9.0% |
| 3 | 6165 | 4.0% |
| 6 | 4274 | 2.8% |
| 5 | 2935 | 1.9% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 155121 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| . | 51707 | |
| 0 | 51707 | |
| 2 | 24333 | |
| 4 | 14000 | 9.0% |
| 3 | 6165 | 4.0% |
| 6 | 4274 | 2.8% |
| 5 | 2935 | 1.9% |
host_is_superhost
Boolean
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 50.6 KiB |
| False | |
|---|---|
| True |
| Value | Count | Frequency (%) |
| False | 38475 | |
| True | 13232 | 25.6% |
multi
Categorical
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 404.1 KiB |
| 0 | |
|---|---|
| 1 |
Length
| Max length | 1 |
|---|---|
| Median length | 1 |
| Mean length | 1 |
| Min length | 1 |
Characters and Unicode
| Total characters | 51707 |
|---|---|
| Distinct characters | 2 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 1 |
|---|---|
| 2nd row | 0 |
| 3rd row | 0 |
| 4th row | 0 |
| 5th row | 0 |
Common Values
| Value | Count | Frequency (%) |
| 0 | 36642 | |
| 1 | 15065 |
Length
Histogram of lengths of the category
Common Values (Plot)
| Value | Count | Frequency (%) |
| 0 | 36642 | |
| 1 | 15065 |
Most occurring characters
| Value | Count | Frequency (%) |
| 0 | 36642 | |
| 1 | 15065 |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 51707 |
Most frequent character per category
Decimal Number
| Value | Count | Frequency (%) |
| 0 | 36642 | |
| 1 | 15065 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 51707 |
Most frequent character per script
Common
| Value | Count | Frequency (%) |
| 0 | 36642 | |
| 1 | 15065 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 51707 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 0 | 36642 | |
| 1 | 15065 |
biz
Categorical
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 404.1 KiB |
| 0 | |
|---|---|
| 1 |
Length
| Max length | 1 |
|---|---|
| Median length | 1 |
| Mean length | 1 |
| Min length | 1 |
Characters and Unicode
| Total characters | 51707 |
|---|---|
| Distinct characters | 2 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 0 |
|---|---|
| 2nd row | 0 |
| 3rd row | 1 |
| 4th row | 1 |
| 5th row | 0 |
Common Values
| Value | Count | Frequency (%) |
| 0 | 33599 | |
| 1 | 18108 |
Length
Histogram of lengths of the category
Common Values (Plot)
| Value | Count | Frequency (%) |
| 0 | 33599 | |
| 1 | 18108 |
Most occurring characters
| Value | Count | Frequency (%) |
| 0 | 33599 | |
| 1 | 18108 |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 51707 |
Most frequent character per category
Decimal Number
| Value | Count | Frequency (%) |
| 0 | 33599 | |
| 1 | 18108 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 51707 |
Most frequent character per script
Common
| Value | Count | Frequency (%) |
| 0 | 33599 | |
| 1 | 18108 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 51707 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 0 | 33599 | |
| 1 | 18108 |
cleanliness_rating
Real number (ℝ)
HIGH CORRELATION
| Distinct | 9 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 9.3906241 |
| Minimum | 2 |
|---|---|
| Maximum | 10 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 404.1 KiB |
Quantile statistics
| Minimum | 2 |
|---|---|
| 5-th percentile | 8 |
| Q1 | 9 |
| median | 10 |
| Q3 | 10 |
| 95-th percentile | 10 |
| Maximum | 10 |
| Range | 8 |
| Interquartile range (IQR) | 1 |
Descriptive statistics
| Standard deviation | 0.95486846 |
|---|---|
| Coefficient of variation (CV) | 0.10168317 |
| Kurtosis | 13.611255 |
| Mean | 9.3906241 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | -2.8502863 |
| Sum | 485561 |
| Variance | 0.91177377 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=9)
| Value | Count | Frequency (%) |
| 10 | 30067 | |
| 9 | 15458 | |
| 8 | 4352 | 8.4% |
| 7 | 947 | 1.8% |
| 6 | 501 | 1.0% |
| 4 | 143 | 0.3% |
| 2 | 143 | 0.3% |
| 5 | 86 | 0.2% |
| 3 | 10 | < 0.1% |
| Value | Count | Frequency (%) |
| 2 | 143 | 0.3% |
| 3 | 10 | < 0.1% |
| 4 | 143 | 0.3% |
| 5 | 86 | 0.2% |
| 6 | 501 | 1.0% |
| 7 | 947 | 1.8% |
| 8 | 4352 | 8.4% |
| 9 | 15458 | |
| 10 | 30067 |
| Value | Count | Frequency (%) |
| 10 | 30067 | |
| 9 | 15458 | |
| 8 | 4352 | 8.4% |
| 7 | 947 | 1.8% |
| 6 | 501 | 1.0% |
| 5 | 86 | 0.2% |
| 4 | 143 | 0.3% |
| 3 | 10 | < 0.1% |
| 2 | 143 | 0.3% |
guest_satisfaction_overall
Real number (ℝ)
HIGH CORRELATION
| Distinct | 53 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 92.628232 |
| Minimum | 20 |
|---|---|
| Maximum | 100 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 404.1 KiB |
Quantile statistics
| Minimum | 20 |
|---|---|
| 5-th percentile | 79 |
| Q1 | 90 |
| median | 95 |
| Q3 | 99 |
| 95-th percentile | 100 |
| Maximum | 100 |
| Range | 80 |
| Interquartile range (IQR) | 9 |
Descriptive statistics
| Standard deviation | 8.9455308 |
|---|---|
| Coefficient of variation (CV) | 0.096574561 |
| Kurtosis | 17.022341 |
| Mean | 92.628232 |
| Median Absolute Deviation (MAD) | 4 |
| Skewness | -3.1749078 |
| Sum | 4789528 |
| Variance | 80.022522 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 100 | 10681 | |
| 98 | 3889 | 7.5% |
| 97 | 3626 | 7.0% |
| 96 | 3532 | 6.8% |
| 93 | 3329 | 6.4% |
| 95 | 3299 | 6.4% |
| 94 | 2615 | 5.1% |
| 90 | 2607 | 5.0% |
| 99 | 2341 | 4.5% |
| 80 | 2059 | 4.0% |
| Other values (43) | 13729 |
| Value | Count | Frequency (%) |
| 20 | 155 | |
| 30 | 8 | < 0.1% |
| 40 | 123 | |
| 44 | 2 | < 0.1% |
| 46 | 1 | < 0.1% |
| 47 | 16 | < 0.1% |
| 50 | 44 | 0.1% |
| 53 | 14 | < 0.1% |
| 54 | 1 | < 0.1% |
| 55 | 4 | < 0.1% |
| Value | Count | Frequency (%) |
| 100 | 10681 | |
| 99 | 2341 | 4.5% |
| 98 | 3889 | 7.5% |
| 97 | 3626 | 7.0% |
| 96 | 3532 | 6.8% |
| 95 | 3299 | 6.4% |
| 94 | 2615 | 5.1% |
| 93 | 3329 | 6.4% |
| 92 | 2025 | 3.9% |
| 91 | 1799 | 3.5% |
bedrooms
Real number (ℝ)
ZEROS
| Distinct | 10 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1.1587599 |
| Minimum | 0 |
|---|---|
| Maximum | 10 |
| Zeros | 4485 |
| Zeros (%) | 8.7% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 404.1 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 1 |
| median | 1 |
| Q3 | 1 |
| 95-th percentile | 2 |
| Maximum | 10 |
| Range | 10 |
| Interquartile range (IQR) | 0 |
Descriptive statistics
| Standard deviation | 0.62741029 |
|---|---|
| Coefficient of variation (CV) | 0.54144976 |
| Kurtosis | 8.692778 |
| Mean | 1.1587599 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 1.3677757 |
| Sum | 59916 |
| Variance | 0.39364367 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=10)
| Value | Count | Frequency (%) |
| 1 | 36333 | |
| 2 | 9290 | 18.0% |
| 0 | 4485 | 8.7% |
| 3 | 1477 | 2.9% |
| 4 | 96 | 0.2% |
| 5 | 10 | < 0.1% |
| 9 | 10 | < 0.1% |
| 6 | 2 | < 0.1% |
| 8 | 2 | < 0.1% |
| 10 | 2 | < 0.1% |
| Value | Count | Frequency (%) |
| 0 | 4485 | 8.7% |
| 1 | 36333 | |
| 2 | 9290 | 18.0% |
| 3 | 1477 | 2.9% |
| 4 | 96 | 0.2% |
| 5 | 10 | < 0.1% |
| 6 | 2 | < 0.1% |
| 8 | 2 | < 0.1% |
| 9 | 10 | < 0.1% |
| 10 | 2 | < 0.1% |
| Value | Count | Frequency (%) |
| 10 | 2 | < 0.1% |
| 9 | 10 | < 0.1% |
| 8 | 2 | < 0.1% |
| 6 | 2 | < 0.1% |
| 5 | 10 | < 0.1% |
| 4 | 96 | 0.2% |
| 3 | 1477 | 2.9% |
| 2 | 9290 | 18.0% |
| 1 | 36333 | |
| 0 | 4485 | 8.7% |
dist
Real number (ℝ)
HIGH CORRELATION UNIQUE
| Distinct | 51707 |
|---|---|
| Distinct (%) | 100.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 3.1912851 |
| Minimum | 0.015044521 |
|---|---|
| Maximum | 25.284557 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 404.1 KiB |
Quantile statistics
| Minimum | 0.015044521 |
|---|---|
| 5-th percentile | 0.53091454 |
| Q1 | 1.4531417 |
| median | 2.6135377 |
| Q3 | 4.2630771 |
| 95-th percentile | 7.7443212 |
| Maximum | 25.284557 |
| Range | 25.269512 |
| Interquartile range (IQR) | 2.8099354 |
Descriptive statistics
| Standard deviation | 2.3938026 |
|---|---|
| Coefficient of variation (CV) | 0.75010613 |
| Kurtosis | 4.969597 |
| Mean | 3.1912851 |
| Median Absolute Deviation (MAD) | 1.3424615 |
| Skewness | 1.7311945 |
| Sum | 165011.78 |
| Variance | 5.7302907 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 5.022963798 | 1 | < 0.1% |
| 0.9267457613 | 1 | < 0.1% |
| 0.9492443402 | 1 | < 0.1% |
| 1.810055679 | 1 | < 0.1% |
| 2.240424781 | 1 | < 0.1% |
| 2.953784515 | 1 | < 0.1% |
| 1.661411982 | 1 | < 0.1% |
| 1.626053492 | 1 | < 0.1% |
| 3.185684333 | 1 | < 0.1% |
| 0.3922062454 | 1 | < 0.1% |
| Other values (51697) | 51697 |
| Value | Count | Frequency (%) |
| 0.0150445207 | 1 | |
| 0.01505879807 | 1 | |
| 0.03466063682 | 1 | |
| 0.03981359742 | 1 | |
| 0.04055333537 | 1 | |
| 0.04056058641 | 1 | |
| 0.04278870764 | 1 | |
| 0.04331472743 | 1 | |
| 0.04333710768 | 1 | |
| 0.05129393071 | 1 |
| Value | Count | Frequency (%) |
| 25.28455675 | 1 | |
| 22.61745814 | 1 | |
| 22.61745145 | 1 | |
| 22.59511526 | 1 | |
| 21.29517392 | 1 | |
| 21.29515096 | 1 | |
| 20.89510207 | 1 | |
| 20.89509463 | 1 | |
| 20.49567803 | 1 | |
| 20.49565772 | 1 |
metro_dist
Real number (ℝ)
UNIQUE
| Distinct | 51707 |
|---|---|
| Distinct (%) | 100.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 0.68153984 |
| Minimum | 0.002301068 |
|---|---|
| Maximum | 14.273577 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 404.1 KiB |
Quantile statistics
| Minimum | 0.002301068 |
|---|---|
| 5-th percentile | 0.11010151 |
| Q1 | 0.24847951 |
| median | 0.41326924 |
| Q3 | 0.73784008 |
| 95-th percentile | 2.1243154 |
| Maximum | 14.273577 |
| Range | 14.271276 |
| Interquartile range (IQR) | 0.48936057 |
Descriptive statistics
| Standard deviation | 0.85802283 |
|---|---|
| Coefficient of variation (CV) | 1.2589474 |
| Kurtosis | 23.703047 |
| Mean | 0.68153984 |
| Median Absolute Deviation (MAD) | 0.20315805 |
| Skewness | 4.0604449 |
| Sum | 35240.38 |
| Variance | 0.73620318 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 2.539380003 | 1 | < 0.1% |
| 0.3365377577 | 1 | < 0.1% |
| 0.1202082532 | 1 | < 0.1% |
| 0.46755128 | 1 | < 0.1% |
| 0.2986401695 | 1 | < 0.1% |
| 0.3943181888 | 1 | < 0.1% |
| 0.3021673129 | 1 | < 0.1% |
| 0.3701270869 | 1 | < 0.1% |
| 0.5588153189 | 1 | < 0.1% |
| 0.2730923921 | 1 | < 0.1% |
| Other values (51697) | 51697 |
| Value | Count | Frequency (%) |
| 0.002301068012 | 1 | |
| 0.003220007615 | 1 | |
| 0.003935058041 | 1 | |
| 0.00394375911 | 1 | |
| 0.004750441048 | 1 | |
| 0.004762350151 | 1 | |
| 0.006157628218 | 1 | |
| 0.006170744841 | 1 | |
| 0.006388847148 | 1 | |
| 0.006405009016 | 1 |
| Value | Count | Frequency (%) |
| 14.27357693 | 1 | |
| 13.31411503 | 1 | |
| 13.31410827 | 1 | |
| 13.0699635 | 1 | |
| 11.68773401 | 1 | |
| 9.598773284 | 1 | |
| 9.573733182 | 1 | |
| 9.286229385 | 1 | |
| 9.174093892 | 1 | |
| 9.151204873 | 1 |
attr_index
Real number (ℝ)
HIGH CORRELATION UNIQUE
| Distinct | 51707 |
|---|---|
| Distinct (%) | 100.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 294.2041 |
| Minimum | 15.152201 |
|---|---|
| Maximum | 4513.5635 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 404.1 KiB |
Quantile statistics
| Minimum | 15.152201 |
|---|---|
| 5-th percentile | 66.675024 |
| Q1 | 136.79738 |
| median | 234.33175 |
| Q3 | 385.75638 |
| 95-th percentile | 728.55276 |
| Maximum | 4513.5635 |
| Range | 4498.4113 |
| Interquartile range (IQR) | 248.959 |
Descriptive statistics
| Standard deviation | 224.75412 |
|---|---|
| Coefficient of variation (CV) | 0.76393945 |
| Kurtosis | 23.037393 |
| Mean | 294.2041 |
| Median Absolute Deviation (MAD) | 114.23113 |
| Skewness | 2.7599805 |
| Sum | 15212412 |
| Variance | 50514.416 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 78.69037927 | 1 | < 0.1% |
| 124.6214213 | 1 | < 0.1% |
| 373.4523724 | 1 | < 0.1% |
| 141.9817664 | 1 | < 0.1% |
| 102.1038061 | 1 | < 0.1% |
| 53.92603171 | 1 | < 0.1% |
| 123.8424983 | 1 | < 0.1% |
| 163.2112525 | 1 | < 0.1% |
| 50.18719008 | 1 | < 0.1% |
| 231.4391473 | 1 | < 0.1% |
| Other values (51697) | 51697 |
| Value | Count | Frequency (%) |
| 15.15220147 | 1 | |
| 15.53291806 | 1 | |
| 16.58197413 | 1 | |
| 16.60073055 | 1 | |
| 16.60073515 | 1 | |
| 19.01913316 | 1 | |
| 19.01914767 | 1 | |
| 19.1378197 | 1 | |
| 19.13782442 | 1 | |
| 19.21394433 | 1 |
| Value | Count | Frequency (%) |
| 4513.563486 | 1 | |
| 4512.59517 | 1 | |
| 4512.345962 | 1 | |
| 4510.73735 | 1 | |
| 4510.436033 | 1 | |
| 4509.914049 | 1 | |
| 4022.618126 | 1 | |
| 3031.840298 | 1 | |
| 3028.991664 | 1 | |
| 2934.133441 | 1 |
attr_index_norm
Real number (ℝ)
HIGH CORRELATION
| Distinct | 51688 |
|---|---|
| Distinct (%) | > 99.9% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 13.423792 |
| Minimum | 0.92630092 |
|---|---|
| Maximum | 100 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 404.1 KiB |
Quantile statistics
| Minimum | 0.92630092 |
|---|---|
| 5-th percentile | 3.0569712 |
| Q1 | 6.3809264 |
| median | 11.468305 |
| Q3 | 17.415082 |
| 95-th percentile | 31.136879 |
| Maximum | 100 |
| Range | 99.073699 |
| Interquartile range (IQR) | 11.034155 |
Descriptive statistics
| Standard deviation | 9.8079845 |
|---|---|
| Coefficient of variation (CV) | 0.73064186 |
| Kurtosis | 9.351918 |
| Mean | 13.423792 |
| Median Absolute Deviation (MAD) | 5.416192 |
| Skewness | 2.1931671 |
| Sum | 694104.03 |
| Variance | 96.19656 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 100 | 20 | < 0.1% |
| 4.166707868 | 1 | < 0.1% |
| 5.020137412 | 1 | < 0.1% |
| 3.849737769 | 1 | < 0.1% |
| 2.033235479 | 1 | < 0.1% |
| 4.669376798 | 1 | < 0.1% |
| 6.153742424 | 1 | < 0.1% |
| 1.892265613 | 1 | < 0.1% |
| 8.72621757 | 1 | < 0.1% |
| 7.991073781 | 1 | < 0.1% |
| Other values (51678) | 51678 |
| Value | Count | Frequency (%) |
| 0.9263009179 | 1 | |
| 1.040227906 | 1 | |
| 1.040956301 | 1 | |
| 1.134200311 | 1 | |
| 1.135137404 | 1 | |
| 1.141278148 | 1 | |
| 1.142220498 | 1 | |
| 1.145817817 | 1 | |
| 1.147309596 | 1 | |
| 1.148114127 | 1 |
| Value | Count | Frequency (%) |
| 100 | 20 | |
| 99.9944775 | 1 | < 0.1% |
| 99.95215309 | 1 | < 0.1% |
| 99.93738572 | 1 | < 0.1% |
| 99.91914511 | 1 | < 0.1% |
| 99.27831239 | 1 | < 0.1% |
| 98.97561989 | 1 | < 0.1% |
| 98.97243581 | 1 | < 0.1% |
| 98.86827875 | 1 | < 0.1% |
| 98.54126635 | 1 | < 0.1% |
rest_index
Real number (ℝ)
HIGH CORRELATION UNIQUE
| Distinct | 51707 |
|---|---|
| Distinct (%) | 100.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 626.8567 |
| Minimum | 19.576924 |
|---|---|
| Maximum | 6696.1568 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 404.1 KiB |
Quantile statistics
| Minimum | 19.576924 |
|---|---|
| 5-th percentile | 93.464041 |
| Q1 | 250.85411 |
| median | 522.05278 |
| Q3 | 832.62899 |
| 95-th percentile | 1615.0761 |
| Maximum | 6696.1568 |
| Range | 6676.5798 |
| Interquartile range (IQR) | 581.77487 |
Descriptive statistics
| Standard deviation | 497.92023 |
|---|---|
| Coefficient of variation (CV) | 0.79431269 |
| Kurtosis | 4.7512364 |
| Mean | 626.8567 |
| Median Absolute Deviation (MAD) | 287.24938 |
| Skewness | 1.6943564 |
| Sum | 32412879 |
| Variance | 247924.55 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 98.25389587 | 1 | < 0.1% |
| 216.20763 | 1 | < 0.1% |
| 631.5788783 | 1 | < 0.1% |
| 206.1115944 | 1 | < 0.1% |
| 130.0507776 | 1 | < 0.1% |
| 80.03435522 | 1 | < 0.1% |
| 226.6451046 | 1 | < 0.1% |
| 156.5323018 | 1 | < 0.1% |
| 71.58261456 | 1 | < 0.1% |
| 381.7061375 | 1 | < 0.1% |
| Other values (51697) | 51697 |
| Value | Count | Frequency (%) |
| 19.5769238 | 1 | |
| 21.45579724 | 1 | |
| 21.45580338 | 1 | |
| 21.49691927 | 1 | |
| 25.02270288 | 1 | |
| 26.50937148 | 1 | |
| 26.72904038 | 1 | |
| 27.90161264 | 1 | |
| 27.90167346 | 1 | |
| 27.93416764 | 1 |
| Value | Count | Frequency (%) |
| 6696.156772 | 1 | |
| 5587.136047 | 1 | |
| 5584.77184 | 1 | |
| 4592.883342 | 1 | |
| 4591.339847 | 1 | |
| 4590.349641 | 1 | |
| 4590.306687 | 1 | |
| 4589.772131 | 1 | |
| 4589.32312 | 1 | |
| 4552.357526 | 1 |
rest_index_norm
Real number (ℝ)
HIGH CORRELATION
| Distinct | 51688 |
|---|---|
| Distinct (%) | > 99.9% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 22.786177 |
| Minimum | 0.59275692 |
|---|---|
| Maximum | 100 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 404.1 KiB |
Quantile statistics
| Minimum | 0.59275692 |
|---|---|
| 5-th percentile | 2.7221578 |
| Q1 | 8.75148 |
| median | 17.542238 |
| Q3 | 32.964603 |
| 95-th percentile | 59.117979 |
| Maximum | 100 |
| Range | 99.407243 |
| Interquartile range (IQR) | 24.213123 |
Descriptive statistics
| Standard deviation | 17.804096 |
|---|---|
| Coefficient of variation (CV) | 0.78135513 |
| Kurtosis | 0.78289621 |
| Mean | 22.786177 |
| Median Absolute Deviation (MAD) | 10.614318 |
| Skewness | 1.0974547 |
| Sum | 1178204.9 |
| Variance | 316.98585 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 100 | 20 | < 0.1% |
| 6.846472824 | 1 | < 0.1% |
| 12.29477012 | 1 | < 0.1% |
| 9.765003832 | 1 | < 0.1% |
| 6.009466453 | 1 | < 0.1% |
| 17.01789375 | 1 | < 0.1% |
| 11.75339783 | 1 | < 0.1% |
| 5.37485833 | 1 | < 0.1% |
| 28.66081974 | 1 | < 0.1% |
| 36.99739056 | 1 | < 0.1% |
| Other values (51678) | 51678 |
| Value | Count | Frequency (%) |
| 0.5927569191 | 1 | |
| 0.6407212807 | 1 | |
| 0.6460305932 | 1 | |
| 0.6549731588 | 1 | |
| 0.6608714797 | 1 | |
| 0.6659262496 | 1 | |
| 0.6670097117 | 1 | |
| 0.6677877225 | 1 | |
| 0.6743712124 | 1 | |
| 0.6746584383 | 1 |
| Value | Count | Frequency (%) |
| 100 | 20 | |
| 99.96639378 | 1 | < 0.1% |
| 99.94483419 | 1 | < 0.1% |
| 99.94389898 | 1 | < 0.1% |
| 99.92248394 | 1 | < 0.1% |
| 99.19076175 | 1 | < 0.1% |
| 98.48673907 | 1 | < 0.1% |
| 98.30841086 | 1 | < 0.1% |
| 98.11497172 | 1 | < 0.1% |
| 98.05204 | 1 | < 0.1% |
lng
Real number (ℝ)
HIGH CORRELATION
| Distinct | 23600 |
|---|---|
| Distinct (%) | 45.6% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 7.4260676 |
| Minimum | -9.22634 |
|---|---|
| Maximum | 23.78602 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 15354 |
| Negative (%) | 29.7% |
| Memory size | 404.1 KiB |
Quantile statistics
| Minimum | -9.22634 |
|---|---|
| 5-th percentile | -9.14439 |
| Q1 | -0.0725 |
| median | 4.873 |
| Q3 | 13.518825 |
| 95-th percentile | 23.73003 |
| Maximum | 23.78602 |
| Range | 33.01236 |
| Interquartile range (IQR) | 13.591325 |
Descriptive statistics
| Standard deviation | 9.7997246 |
|---|---|
| Coefficient of variation (CV) | 1.3196385 |
| Kurtosis | -1.0033876 |
| Mean | 7.4260676 |
| Median Absolute Deviation (MAD) | 7.605 |
| Skewness | 0.033300662 |
| Sum | 383979.68 |
| Variance | 96.034602 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 12.472 | 98 | 0.2% |
| -9.133 | 83 | 0.2% |
| 12.47 | 78 | 0.2% |
| 12.469 | 76 | 0.1% |
| 12.468 | 75 | 0.1% |
| 12.477 | 71 | 0.1% |
| 12.467 | 64 | 0.1% |
| 23.729 | 63 | 0.1% |
| -9.144 | 61 | 0.1% |
| -9.148 | 59 | 0.1% |
| Other values (23590) | 50979 |
| Value | Count | Frequency (%) |
| -9.22634 | 2 | |
| -9.22599 | 1 | |
| -9.22594 | 2 | |
| -9.22516 | 1 | |
| -9.22476 | 2 | |
| -9.2219 | 2 | |
| -9.2211 | 2 | |
| -9.21994 | 1 | |
| -9.21973 | 1 | |
| -9.21947 | 1 |
| Value | Count | Frequency (%) |
| 23.78602 | 2 | |
| 23.77931 | 2 | |
| 23.77891 | 2 | |
| 23.77889 | 1 | < 0.1% |
| 23.77812 | 1 | < 0.1% |
| 23.778 | 2 | |
| 23.77702 | 2 | |
| 23.77682 | 2 | |
| 23.776 | 3 | |
| 23.775 | 2 |
lat
Real number (ℝ)
HIGH CORRELATION
| Distinct | 21484 |
|---|---|
| Distinct (%) | 41.5% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 45.671128 |
| Minimum | 37.953 |
|---|---|
| Maximum | 52.64141 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 404.1 KiB |
Quantile statistics
| Minimum | 37.953 |
|---|---|
| 5-th percentile | 37.97893 |
| Q1 | 41.39951 |
| median | 47.50669 |
| Q3 | 51.471885 |
| 95-th percentile | 52.39158 |
| Maximum | 52.64141 |
| Range | 14.68841 |
| Interquartile range (IQR) | 10.072375 |
Descriptive statistics
| Standard deviation | 5.2492632 |
|---|---|
| Coefficient of variation (CV) | 0.11493614 |
| Kurtosis | -1.554394 |
| Mean | 45.671128 |
| Median Absolute Deviation (MAD) | 4.86972 |
| Skewness | -0.17958308 |
| Sum | 2361517 |
| Variance | 27.554764 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 38.711 | 136 | 0.3% |
| 41.896 | 126 | 0.2% |
| 41.897 | 118 | 0.2% |
| 38.712 | 116 | 0.2% |
| 41.899 | 103 | 0.2% |
| 38.71 | 99 | 0.2% |
| 41.895 | 93 | 0.2% |
| 41.908 | 92 | 0.2% |
| 38.713 | 85 | 0.2% |
| 41.907 | 83 | 0.2% |
| Other values (21474) | 50656 |
| Value | Count | Frequency (%) |
| 37.953 | 2 | |
| 37.95302 | 2 | |
| 37.95368 | 2 | |
| 37.9537 | 2 | |
| 37.954 | 3 | |
| 37.95463 | 1 | < 0.1% |
| 37.95466 | 1 | < 0.1% |
| 37.95482 | 2 | |
| 37.955 | 2 | |
| 37.95514 | 1 | < 0.1% |
| Value | Count | Frequency (%) |
| 52.64141 | 2 | |
| 52.63967 | 2 | |
| 52.63429 | 1 | |
| 52.63311 | 1 | |
| 52.6208 | 2 | |
| 52.61913 | 1 | |
| 52.61597 | 2 | |
| 52.61588 | 2 | |
| 52.60997 | 2 | |
| 52.60922 | 2 |
city
Categorical
HIGH CORRELATION
| Distinct | 10 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 404.1 KiB |
| london | |
|---|---|
| rome | |
| paris | |
| lisbon | |
| athens | |
| Other values (5) |
Length
| Max length | 9 |
|---|---|
| Median length | 6 |
| Mean length | 5.9621134 |
| Min length | 4 |
Characters and Unicode
| Total characters | 308283 |
|---|---|
| Distinct characters | 17 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | amsterdam |
|---|---|
| 2nd row | amsterdam |
| 3rd row | amsterdam |
| 4th row | amsterdam |
| 5th row | amsterdam |
Common Values
| Value | Count | Frequency (%) |
| london | 9993 | |
| rome | 9027 | |
| paris | 6688 | |
| lisbon | 5763 | |
| athens | 5280 | |
| budapest | 4022 | |
| vienna | 3537 | 6.8% |
| barcelona | 2833 | 5.5% |
| berlin | 2484 | 4.8% |
| amsterdam | 2080 | 4.0% |
Length
Histogram of lengths of the category
Common Values (Plot)
| Value | Count | Frequency (%) |
| london | 9993 | |
| rome | 9027 | |
| paris | 6688 | |
| lisbon | 5763 | |
| athens | 5280 | |
| budapest | 4022 | |
| vienna | 3537 | 6.8% |
| barcelona | 2833 | 5.5% |
| berlin | 2484 | 4.8% |
| amsterdam | 2080 | 4.0% |
Most occurring characters
| Value | Count | Frequency (%) |
| n | 43420 | |
| o | 37609 | |
| a | 29353 | |
| e | 29263 | |
| s | 23833 | |
| r | 23112 | |
| l | 21073 | |
| i | 18472 | 6.0% |
| d | 16095 | 5.2% |
| b | 15102 | 4.9% |
| Other values (7) | 50951 |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 308283 |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| n | 43420 | |
| o | 37609 | |
| a | 29353 | |
| e | 29263 | |
| s | 23833 | |
| r | 23112 | |
| l | 21073 | |
| i | 18472 | 6.0% |
| d | 16095 | 5.2% |
| b | 15102 | 4.9% |
| Other values (7) | 50951 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 308283 |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| n | 43420 | |
| o | 37609 | |
| a | 29353 | |
| e | 29263 | |
| s | 23833 | |
| r | 23112 | |
| l | 21073 | |
| i | 18472 | 6.0% |
| d | 16095 | 5.2% |
| b | 15102 | 4.9% |
| Other values (7) | 50951 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 308283 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| n | 43420 | |
| o | 37609 | |
| a | 29353 | |
| e | 29263 | |
| s | 23833 | |
| r | 23112 | |
| l | 21073 | |
| i | 18472 | 6.0% |
| d | 16095 | 5.2% |
| b | 15102 | 4.9% |
| Other values (7) | 50951 |
weekdays
Boolean
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 50.6 KiB |
| False | |
|---|---|
| True |
| Value | Count | Frequency (%) |
| False | 26207 | |
| True | 25500 |
| realSum | cleanliness_rating | guest_satisfaction_overall | bedrooms | dist | metro_dist | attr_index | attr_index_norm | rest_index | rest_index_norm | lng | lat | room_type | room_shared | room_private | person_capacity | host_is_superhost | multi | biz | city | weekdays | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| realSum | 1.000 | 0.005 | 0.014 | 0.226 | -0.061 | -0.133 | 0.385 | 0.494 | 0.333 | 0.310 | -0.352 | 0.357 | 0.019 | 0.000 | 0.029 | 0.034 | 0.014 | 0.008 | 0.025 | 0.027 | 0.000 |
| cleanliness_rating | 0.005 | 1.000 | 0.630 | 0.040 | -0.024 | 0.041 | -0.072 | -0.112 | -0.080 | -0.048 | 0.134 | -0.100 | 0.045 | 0.043 | 0.043 | 0.010 | 0.323 | 0.048 | 0.132 | 0.067 | 0.000 |
| guest_satisfaction_overall | 0.014 | 0.630 | 1.000 | 0.063 | 0.027 | 0.055 | -0.114 | -0.096 | -0.135 | -0.073 | 0.173 | -0.024 | 0.048 | 0.033 | 0.058 | 0.016 | 0.367 | 0.061 | 0.238 | 0.074 | 0.000 |
| bedrooms | 0.226 | 0.040 | 0.063 | 1.000 | -0.016 | 0.072 | -0.036 | -0.098 | -0.037 | -0.059 | 0.018 | -0.103 | 0.228 | 0.042 | 0.317 | 0.348 | 0.028 | 0.029 | 0.016 | 0.059 | 0.010 |
| dist | -0.061 | -0.024 | 0.027 | -0.016 | 1.000 | 0.320 | -0.405 | -0.219 | -0.377 | -0.526 | -0.199 | 0.440 | 0.153 | 0.026 | 0.214 | 0.076 | 0.062 | 0.036 | 0.157 | 0.207 | 0.000 |
| metro_dist | -0.133 | 0.041 | 0.055 | 0.072 | 0.320 | 1.000 | -0.224 | -0.268 | -0.222 | -0.324 | -0.043 | 0.009 | 0.064 | 0.019 | 0.089 | 0.021 | 0.012 | 0.030 | 0.099 | 0.114 | 0.000 |
| attr_index | 0.385 | -0.072 | -0.114 | -0.036 | -0.405 | -0.224 | 1.000 | 0.765 | 0.935 | 0.662 | -0.262 | 0.044 | 0.019 | 0.017 | 0.020 | 0.020 | 0.017 | 0.017 | 0.091 | 0.146 | 0.000 |
| attr_index_norm | 0.494 | -0.112 | -0.096 | -0.098 | -0.219 | -0.268 | 0.765 | 1.000 | 0.634 | 0.558 | -0.271 | 0.512 | 0.026 | 0.000 | 0.037 | 0.046 | 0.095 | 0.045 | 0.102 | 0.200 | 0.012 |
| rest_index | 0.333 | -0.080 | -0.135 | -0.037 | -0.377 | -0.222 | 0.935 | 0.634 | 1.000 | 0.683 | -0.344 | -0.017 | 0.048 | 0.028 | 0.061 | 0.038 | 0.059 | 0.008 | 0.134 | 0.223 | 0.000 |
| rest_index_norm | 0.310 | -0.048 | -0.073 | -0.059 | -0.526 | -0.324 | 0.662 | 0.558 | 0.683 | 1.000 | -0.108 | 0.038 | 0.118 | 0.021 | 0.165 | 0.036 | 0.024 | 0.041 | 0.101 | 0.269 | 0.082 |
| lng | -0.352 | 0.134 | 0.173 | 0.018 | -0.199 | -0.043 | -0.262 | -0.271 | -0.344 | -0.108 | 1.000 | -0.210 | 0.232 | 0.039 | 0.324 | 0.141 | 0.217 | 0.089 | 0.218 | 1.000 | 0.033 |
| lat | 0.357 | -0.100 | -0.024 | -0.103 | 0.440 | 0.009 | 0.044 | 0.512 | -0.017 | 0.038 | -0.210 | 1.000 | 0.247 | 0.044 | 0.346 | 0.123 | 0.158 | 0.120 | 0.163 | 0.993 | 0.027 |
| room_type | 0.019 | 0.045 | 0.048 | 0.228 | 0.153 | 0.064 | 0.019 | 0.026 | 0.048 | 0.118 | 0.232 | 0.247 | 1.000 | 1.000 | 1.000 | 0.379 | 0.058 | 0.137 | 0.058 | 0.297 | 0.006 |
| room_shared | 0.000 | 0.043 | 0.033 | 0.042 | 0.026 | 0.019 | 0.017 | 0.000 | 0.028 | 0.021 | 0.039 | 0.044 | 1.000 | 1.000 | 0.063 | 0.053 | 0.027 | 0.015 | 0.044 | 0.079 | 0.000 |
| room_private | 0.029 | 0.043 | 0.058 | 0.317 | 0.214 | 0.089 | 0.020 | 0.037 | 0.061 | 0.165 | 0.324 | 0.346 | 1.000 | 0.063 | 1.000 | 0.534 | 0.049 | 0.137 | 0.040 | 0.411 | 0.007 |
| person_capacity | 0.034 | 0.010 | 0.016 | 0.348 | 0.076 | 0.021 | 0.020 | 0.046 | 0.038 | 0.036 | 0.141 | 0.123 | 0.379 | 0.053 | 0.534 | 1.000 | 0.036 | 0.061 | 0.112 | 0.154 | 0.011 |
| host_is_superhost | 0.014 | 0.323 | 0.367 | 0.028 | 0.062 | 0.012 | 0.017 | 0.095 | 0.059 | 0.024 | 0.217 | 0.158 | 0.058 | 0.027 | 0.049 | 0.036 | 1.000 | 0.097 | 0.108 | 0.220 | 0.004 |
| multi | 0.008 | 0.048 | 0.061 | 0.029 | 0.036 | 0.030 | 0.017 | 0.045 | 0.008 | 0.041 | 0.089 | 0.120 | 0.137 | 0.015 | 0.137 | 0.061 | 0.097 | 1.000 | 0.471 | 0.123 | 0.002 |
| biz | 0.025 | 0.132 | 0.238 | 0.016 | 0.157 | 0.099 | 0.091 | 0.102 | 0.134 | 0.101 | 0.218 | 0.163 | 0.058 | 0.044 | 0.040 | 0.112 | 0.108 | 0.471 | 1.000 | 0.230 | 0.017 |
| city | 0.027 | 0.067 | 0.074 | 0.059 | 0.207 | 0.114 | 0.146 | 0.200 | 0.223 | 0.269 | 1.000 | 0.993 | 0.297 | 0.079 | 0.411 | 0.154 | 0.220 | 0.123 | 0.230 | 1.000 | 0.046 |
| weekdays | 0.000 | 0.000 | 0.000 | 0.010 | 0.000 | 0.000 | 0.000 | 0.012 | 0.000 | 0.082 | 0.033 | 0.027 | 0.006 | 0.000 | 0.007 | 0.011 | 0.004 | 0.002 | 0.017 | 0.046 | 1.000 |
A simple visualization of nullity by column.
Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.
| realSum | room_type | room_shared | room_private | person_capacity | host_is_superhost | multi | biz | cleanliness_rating | guest_satisfaction_overall | bedrooms | dist | metro_dist | attr_index | attr_index_norm | rest_index | rest_index_norm | lng | lat | city | weekdays | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | 194.033698 | Private room | False | True | 2.0 | False | 1 | 0 | 10.0 | 93.0 | 1 | 5.022964 | 2.539380 | 78.690379 | 4.166708 | 98.253896 | 6.846473 | 4.90569 | 52.41772 | amsterdam | True |
| 1 | 344.245776 | Private room | False | True | 4.0 | False | 0 | 0 | 8.0 | 85.0 | 1 | 0.488389 | 0.239404 | 631.176378 | 33.421209 | 837.280757 | 58.342928 | 4.90005 | 52.37432 | amsterdam | True |
| 2 | 264.101422 | Private room | False | True | 2.0 | False | 0 | 1 | 9.0 | 87.0 | 1 | 5.748312 | 3.651621 | 75.275877 | 3.985908 | 95.386955 | 6.646700 | 4.97512 | 52.36103 | amsterdam | True |
| 3 | 433.529398 | Private room | False | True | 4.0 | False | 0 | 1 | 9.0 | 90.0 | 2 | 0.384862 | 0.439876 | 493.272534 | 26.119108 | 875.033098 | 60.973565 | 4.89417 | 52.37663 | amsterdam | True |
| 4 | 485.552926 | Private room | False | True | 2.0 | True | 0 | 0 | 10.0 | 98.0 | 1 | 0.544738 | 0.318693 | 552.830324 | 29.272733 | 815.305740 | 56.811677 | 4.90051 | 52.37508 | amsterdam | True |
| 5 | 552.808567 | Private room | False | True | 3.0 | False | 0 | 0 | 8.0 | 100.0 | 2 | 2.131420 | 1.904668 | 174.788957 | 9.255191 | 225.201662 | 15.692376 | 4.87699 | 52.38966 | amsterdam | True |
| 6 | 215.124317 | Private room | False | True | 2.0 | False | 0 | 0 | 10.0 | 94.0 | 1 | 1.881092 | 0.729747 | 200.167652 | 10.599010 | 242.765524 | 16.916251 | 4.91570 | 52.38296 | amsterdam | True |
| 7 | 2771.307384 | Entire home/apt | False | False | 4.0 | True | 0 | 0 | 10.0 | 100.0 | 3 | 1.686807 | 1.458404 | 208.808109 | 11.056528 | 272.313823 | 18.975219 | 4.88467 | 52.38749 | amsterdam | True |
| 8 | 1001.804420 | Entire home/apt | False | False | 4.0 | False | 0 | 0 | 9.0 | 96.0 | 2 | 3.719141 | 1.196112 | 106.226456 | 5.624761 | 133.876202 | 9.328686 | 4.86459 | 52.40175 | amsterdam | True |
| 9 | 276.521454 | Private room | False | True | 2.0 | False | 1 | 0 | 10.0 | 88.0 | 1 | 3.142361 | 0.924404 | 206.252862 | 10.921226 | 238.291258 | 16.604478 | 4.87600 | 52.34700 | amsterdam | True |
| realSum | room_type | room_shared | room_private | person_capacity | host_is_superhost | multi | biz | cleanliness_rating | guest_satisfaction_overall | bedrooms | dist | metro_dist | attr_index | attr_index_norm | rest_index | rest_index_norm | lng | lat | city | weekdays | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 51697 | 289.988005 | Entire home/apt | False | False | 2.0 | False | 0 | 1 | 9.0 | 80.0 | 0 | 7.413283 | 0.507324 | 163.954478 | 11.397115 | 385.327220 | 6.896686 | -0.23339 | 51.49979 | london | False |
| 51698 | 442.625650 | Entire home/apt | False | False | 2.0 | False | 0 | 1 | 10.0 | 80.0 | 1 | 4.138245 | 0.573529 | 447.168487 | 31.084425 | 708.750594 | 12.685401 | -0.06792 | 51.50893 | london | False |
| 51699 | 637.832498 | Entire home/apt | False | False | 2.0 | False | 0 | 1 | 7.0 | 40.0 | 1 | 4.415848 | 0.388140 | 329.957773 | 22.936651 | 740.131070 | 13.247057 | -0.06539 | 51.51684 | london | False |
| 51700 | 90.547755 | Private room | False | True | 2.0 | False | 0 | 0 | 10.0 | 100.0 | 1 | 12.200414 | 3.080764 | 103.298588 | 7.180688 | 207.527974 | 3.714389 | 0.04661 | 51.49376 | london | False |
| 51701 | 362.191020 | Entire home/apt | False | False | 4.0 | False | 0 | 0 | 8.0 | 100.0 | 2 | 8.551082 | 1.168158 | 131.619294 | 9.149370 | 304.939017 | 5.457877 | -0.18818 | 51.44146 | london | False |
| 51702 | 1035.066676 | Private room | False | True | 2.0 | False | 0 | 1 | 10.0 | 100.0 | 0 | 5.155373 | 0.883829 | 271.191201 | 18.851558 | 528.042180 | 9.451035 | -0.05357 | 51.51255 | london | False |
| 51703 | 181.095510 | Private room | False | True | 2.0 | False | 1 | 0 | 10.0 | 100.0 | 1 | 5.072177 | 0.344055 | 268.165870 | 18.641255 | 554.906232 | 9.931855 | -0.05620 | 51.51823 | london | False |
| 51704 | 420.517886 | Entire home/apt | False | False | 2.0 | False | 0 | 0 | 10.0 | 98.0 | 1 | 6.709982 | 0.926188 | 181.892001 | 12.644022 | 395.397885 | 7.076933 | -0.22172 | 51.52180 | london | False |
| 51705 | 217.314612 | Private room | False | True | 2.0 | False | 0 | 0 | 10.0 | 94.0 | 1 | 6.736940 | 0.353634 | 184.278328 | 12.809905 | 471.029678 | 8.430610 | -0.22286 | 51.49715 | london | False |
| 51706 | 489.193067 | Entire home/apt | False | False | 2.0 | False | 0 | 0 | 9.0 | 92.0 | 1 | 4.174953 | 0.610443 | 434.954210 | 30.235363 | 697.673227 | 12.487135 | -0.06739 | 51.50889 | london | False |